Project Costing Tables

 

Column Name Column Type Length Default Value Description Enumeration
ActivityDate datetime 8      
AddnlDesc nvarchar max      
BillingReference varchar max      
BillOnHold bit 1 0    
Description varchar 35      
DistCode pDistCode 6      
ExtCost pDecimal 13 0    
ExtIncome pDecimal 13 0    
ExtIncomeBilled pDecimal 13 0    
FiscalPeriod smallint 2      
FiscalYear smallint 2      
GLAcct pGlAcct 40      
GLAcctAccruedIncome pGlAcct 40      
GLAcctAdjustments pGlAcct 40      
GLAcctCost pGlAcct 40      
GLAcctFixedFeeBilling pGlAcct 40      
GLAcctIncome pGlAcct 40      
GLAcctOverheadContra pGlAcct 40      
GLAcctPayrollClearing pGlAcct 40      
GLAcctWIP pGlAcct 40      
Id int 4      
LinkSeqNum int 4      
LocId pLocID 10      
OverheadPosted pDecimal 13 0    
ProjectDetailId int 4      
Qty pDecimal 13 0    
QtyBilled pDecimal 13 0    
QtyInvoiced pDecimal 13 0    
RateId varchar 10      
RcptId int 4      
Reference varchar 24      
ResourceId varchar 24      
Source tinyint 1   Source 0 = Time Ticket, 1 = Transaction, 2 = Overhead, 3 = Adjustment, 4 = Deposit, 5 = Billing, 6 = Credit Memo, 7 = Unbill, 8 = AP Invoice, 9 = PO, 10 = Unknown, 11 = PO Receipt, 12 = PO Invoice, 13 = SD, 14 = PC
SourceId uniqueidentifier 16      
SourceReference varchar max      
Status tinyint 1   Status 0 = On Order, 1 = Unposted, 2 = Posted, 3 = Work In Process, 4 = Billed, 5 = Completed, 6 = Deleted
TaxClass tinyint 1      
ts timestamp 8      
Type tinyint 1   Type 0 = Time, 1 = Material, 2 = Expense, 3 = Other, 4 = Deposit, 5 = Deposit Applied, 6 = Fixed Fee Billing, 7 = Credit Memo
Uom pUom 5      
CF xml -1      
LinkId int 4      
Column Name Column Type Length Default Value Description Enumeration
AddnlDesc nvarchar max      
Description varchar 35      
ExtCost pDecimal 13 0    
ExtIncome pDecimal 13 0    
FiscalPeriod smallint 2      
FiscalYear smallint 2      
Id int 4      
IncDec tinyint 1   Increase / Decrease Flag 0 = Increase, 1 = Decrease
ProjectDetailId int 4      
Qty pDecimal 13 0    
Status tinyint 1   Status 0 = Posted, 1 = Billed
TransDate datetime 8      
ts timestamp 8      
Type tinyint 1   Type 0 = Time, 1 = Material, 2 = Expense, 3 = Other, 4 = Deposit, 5 = Deposit Applied, 6 = Fixed Fee Billing
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
GLAcctAccrual pGlAcct 40      
Description varchar 25      
DistCode pDistCode 6      
GLAcctAccruedIncome pGlAcct 40      
GLAcctAdjustments pGlAcct 40      
GLAcctCost pGlAcct 40      
GLAcctFixedFeeBilling pGlAcct 40      
GLAcctIncome pGlAcct 40      
GLAcctOverheadContra pGlAcct 40      
GLAcctPayrollClearing pGlAcct 40      
GLAcctWIP pGlAcct 40      
GLAcctBillingExcess pGLAcct 40      
GLAcctEarningExcess pGLAcct 40      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Cost pDecimal 13 0    
DefaultYN bit 1 0    
EarnCode varchar 3      
EmpId pEmpID 11      
Id int 4      
Rate pDecimal 13 0    
RateId varchar 10      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 35      
Id int 4      
LocId varchar 10      
ProjectDetailId int 4      
Qty pDecimal 13 0    
RateId varchar 10      
ResourceId varchar 24      
ts timestamp 8      
Type tinyint 1   Type 0 = Time, 1 = Material, 2 = Expense, 3 = Other
UnitCost pDecimal 13 0    
UnitPrice pDecimal 13 0    
Uom pUom 5      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint        
PostRun pPostRun        
BatchID pBatchId        
ProjectID int 4      
ProjectName nvarchar 10      
CustID pCustID 10      
CustName nvarchar 30      
ProjectDescription nvarchar 30      
DistCode nvarchar 6      
Rep1Id pSalesRep 3      
Rep2Id pSalesRep 3      
ProjectManager pEmpID 11      
FiscalPeriod smallint 2 0    
FiscalYear smallint 2 0    
AdjustDate datetime        
FixedFeeAmount pDecimal 13      
BilledAmount pDecimal 13      
EstimatedCost pDecimal 13      
EstimatedHour pDecimal 13      
PostedCost pDecimal 13      
PostedHour pDecimal 13      
PercentCostCompletion pDecimal 13      
PercentHourCompletion pDecimal 13      
OverridePercent pDecimal 13 0    
EarnedIncome pDecimal 13      
PostedAdjustAmount pDecimal 13      
NetAdjustAmount pDecimal 13      
GLAcctIncome pGLAcct 40      
GLAcctOffset pGLAcct 40      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
DepositAmtApply pDecimal 13 0    
DepositAmtAvail pDecimal 13 0    
Id int 4      
ProjectDetailId int 4      
TransId pTransID 8      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
AddnlDesc nvarchar max      
CatId varchar 2      
Descr varchar 35      
EntryNum int 4      
ExtCost pDecimal 13 0    
ExtCostFgn pDecimal 13 0    
ExtPrice pDecimal 13 0    
ExtPriceFgn pDecimal 13 0    
LineSeq int 4      
ProjectDetailId int 4      
Qty pDecimal 13 0    
Rep1CommRate pDecimal 13 0    
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
TaxClass tinyint 1      
TransId pTransID 8      
ts timestamp 8      
UnitCommBasis pDecimal 13      
UnitCommBasisFgn pDecimal 13      
ZeroPrint bit 1 0    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BatchId pBatchID 6 '######'    
CalcGainLoss pDecimal 13 0    
CurrencyID pCurrency 6      
CustId pCustID 10      
CustPONum varchar 25      
DiscAmt pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
DiscDueDate datetime 8      
DistCode pDistCode 6      
ExchRate pDecimal 13 -1    
FiscalPeriod smallint 2 0    
FiscalYear smallint 2 0    
HoldYn bit 1 0    
InvcDate datetime 8      
InvcNum pInvoiceNum 15      
LocId pLocID 10      
NetDueDate datetime 8      
NonTaxSubtotal pDecimal 13 0    
NonTaxSubtotalFgn pDecimal 13 0    
OrderDate datetime 8      
OrgInvcExchRate pDecimal 13 -1    
OrgInvcNum pInvoiceNum 15      
PrintOption nvarchar 510      
PrintStatus tinyint 1 0 Print Status 0 = Unprinted, 1 = Printed
Rep1CommRate pDecimal 13 0    
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
SalesTax pDecimal 13 0    
SalesTaxFgn pDecimal 13 0    
SourceId uniqueidentifier 16      
TaxableYN bit 1      
TaxAmtAdj pDecimal 13 0    
TaxAmtAdjFgn pDecimal 13 0    
TaxClassAdj tinyint 1 0    
TaxGrpID pTaxLoc 10      
TaxLocAdj pTaxLoc 10      
TaxSubtotal pDecimal 13 0    
TaxSubtotalFgn pDecimal 13 0    
TermsCode pTermsCode 6      
TotCost pDecimal 13 0    
TotCostFgn pDecimal 13 0    
TransId pTransID 8      
TransType smallint 2      
ts timestamp 8      
VoidYn bit 1 0    
CF xml -1      
*TaxGrpId2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
Level tinyint 1 -1    
LiabilityAcct pGlAcct 40      
NonTaxable pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
Taxable pDecimal 13 0    
TaxableFgn pDecimal 13 0    
TaxAmt pDecimal 13 0    
TaxAmtFgn pDecimal 13 0    
TaxClass tinyint 1 0    
TaxLocID pTaxLoc 10      
TransId pTransID 8      
ts timestamp 8      
CF xml -1      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount pGlAcct        
Column Name Column Type Length Default Value Description Enumeration
Description varchar 50      
Expense pDecimal 13 0    
Hours pDecimal 13 0    
Material pDecimal 13 0    
OhAllCode varchar 6      
Other pDecimal 13 0    
Time pDecimal 13 0    
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 30      
PhaseId varchar 10      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
CurrOH pDecimal 13      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
Id int 4      
OhAllCode varchar 6      
TransDate datetime 8      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
CustId pCustID 10      
Id int 4      
PrintOption nvarchar 510      
ProjectName varchar 10      
ts timestamp 8      
Type tinyint 1 0 Type 0 = General, 1 = Job Costing, 2 = Administrative
Column Name Column Type Length Default Value Description Enumeration
ActEndDate datetime 8      
ActStartDate datetime 8      
AddnlDesc nvarchar max      
Billable bit 1 -1    
BillOnHold bit 1 0    
CustPONum varchar 25      
Description varchar 30      
DistCode varchar 6      
EstEndDate datetime 8      
EstStartDate datetime 8      
ExpenseMarkup pDecimal 13 0    
FixedFee bit 1 0    
FixedFeeAmt pDecimal 13 0    
Id int 4      
LastDateBilled datetime 8      
MaterialMarkup pDecimal 13 0    
OhAllCode varchar 6      
OrderDate datetime 8      
OtherMarkup pDecimal 13 0    
OverrideRate pDecimal 13 0    
PhaseId varchar 10      
ProjectId int 4      
ProjectManager pEmpID 11      
RateId varchar 10      
Rep1CommRate pDecimal 13 0    
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
Speculative bit 1 0    
Status tinyint 1 0 Project Detail Status 0 = Active, 1 = Hold, 2 = Completed
TaskId varchar 10      
TaxClass tinyint 1 0    
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 50      
RateId varchar 10      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint        
AdjustBatchID bigint        
ProjectID int 4      
ProjectName nvarchar 10      
CustID pCustID 10      
ProjectDescription nvarchar 30      
DistCode nvarchar 6      
Rep1Id pSalesRep 3      
Rep2Id pSalesRep 3      
ProjectManager pEmpID 11      
FixedFeeAmt pDecimal 13      
BilledAmount pDecimal 13      
EstimatedCost pDecimal 13      
EstimatedHour pDecimal 13      
PostedCost pDecimal 13      
PostedHour pDecimal 13      
PercentCostCompletion pDecimal 13      
PercentHourCompletion pDecimal 13      
OverridePercent pDecimal 13 0    
EarnedIncome pDecimal 13      
PostedAdjustAmount pDecimal 13      
NetAdjustAmount pDecimal 13      
GLAcctIncome pGLAcct 40      
GLAcctBillingExcess pGLAcct 40      
GLAcctEarningExcess pGLAcct 40      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID integer        
BatchID pBatchID 6      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
Filter nvarchar max      
DisplayFilter nvarchar max      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 30      
TaskId varchar 10      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
AddnlDesc nvarchar max      
BatchId pBatchID 6      
BillingRate pDecimal 13 0    
DepartmentId varchar 10      
Description varchar 35      
EarnCode varchar 3      
EmployeeId pEmpID 11      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
Id int 4      
LaborClass varchar 25      
LocalCode varchar 4      
Pieces pDecimal 13 0    
ProjectDetailId int 4      
Qty pDecimal 13 -1    
RateId varchar 10      
SeqNo varchar 8      
StateCode varchar 2      
SUIState varchar 2      
TransDate datetime 8      
ts timestamp 8      
UnitCost pDecimal 13 0    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
AddnlDesc nvarchar max      
BatchId pBatchID 6      
Description varchar 35      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
GLAcct pGlAcct 40      
HistSeqNum int 4      
Id int 4      
ItemId pItemID 24      
LinkSeqNum int 4      
LocId pLocID 10      
Markup pDecimal 13 0    
ProjectDetailId int 4      
QtyFilled pDecimal 13 0    
QtyNeed pDecimal 13 0    
QtySeqNum int 4      
QtySeqNum_Cmtd int 4      
TaxClass tinyint 1      
TransDate datetime 8      
TransType tinyint 1 0 Transaction Type 0 = Material Requisition, 1 = Material Return, 2 = Expense, 3 = Other
ts timestamp 8      
UnitCost pDecimal 13 0    
Uom pUom 5      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
EntryNum int 4      
Id int 4      
Markup pDecimal 13 0    
ProjectDetailId int 4      
TransId int 4      
ts timestamp 8      
Type tinyint 1 0 Type 0 = Material, 1 = Expense, 2 = Other
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Cmnt varchar 35      
ExtLocA int 4      
ExtLocB int 4      
HistSeqNum int 4      
Id int 4      
LotNum pLotNum 16      
QtyFilled pDecimal 13 0    
QtyNeed pDecimal 13 0    
QtySeqNum int 4      
QtySeqNum_Cmtd int 4      
QtySeqNum_Ext int 4      
TransId int 4      
ts timestamp 8      
UnitCost pDecimal 13 0    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Cmnt varchar 35      
ExtLocA int 4      
ExtLocB int 4      
HistSeqNum int 4      
Id int 4      
LotNum pLotNum 16      
SerNum pSerNum 35      
TransId int 4      
ts timestamp 8      
UnitCost pDecimal 13      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BatchId pBatchID 6      
ConsolidatedBilling bit 1 0    
CurrencyId pCurrency 6      
ExchRate pDecimal 13 0    
Filter varchar max      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
AddnlDesc nvarchar max      
Description varchar 35      
ExtIncomeBill pDecimal 13 0    
HeaderId int 4      
Id int 4      
QtyBill pDecimal 13 0    
SelectYn bit 1 -1    
ts timestamp 8      
BatchId pBatchID 6      
ExtCost pDecimal 13      
ResourceId nvarchar 24      
LocId pLocId 10      
Uom pUom 5      
ExtIncome pDecimal 13      
Qty pDecimal 13      
ActivityDate datetime 8      
Type tinyint 1   Activity Type 0 = Time, 1 = Material, 2 = Expense, 3 = Other, 4 = Deposit, 5 = Deposit Applied, 6 = Fixed Fee Billing, 7 = Credit Memo
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BatchId pBatchID 6      
DepositAmt pDecimal 13 0    
DepositAmtApply pDecimal 13 0    
DepositAmtAvail pDecimal 13 0    
FixedFeeAmtApply pDecimal 13 0    
FixedFeeAmtAvail pDecimal 13 0    
Id int 4      
ProjectDetailId int 4      
ts timestamp 8      
CustId pCustId 10      
ProjectName nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
FixedFee bit 1      
FixedFeeAmt pDecimal 13      
ProjectDetailDescription nvarchar 30      
CF xml -1